Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	21435
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 MiB
Average record size in memory	176.0 B

Variable types

Numeric	16
DateTime	1
Categorical	4

Alerts

`bathrooms` is highly overall correlated with `grade` and 3 other fields	High correlation
`bedrooms` is highly overall correlated with `sqft_above` and 1 other fields	High correlation
`floors` is highly overall correlated with `yr_built`	High correlation
`grade` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`price` is highly overall correlated with `grade` and 3 other fields	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living15` is highly overall correlated with `grade` and 3 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 1 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.2%)	Imbalance
`id` has unique values	Unique
`sqft_basement` has 13015 (60.7%) zeros	Zeros
`yr_renovated` has 20525 (95.8%) zeros	Zeros

Reproduction

Analysis started	2025-10-31 05:44:19.857840
Analysis finished	2025-10-31 05:44:43.500475
Duration	23.64 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

id
Real number (ℝ)

Unique

Distinct	21435
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.580867 × 10⁹

Minimum	1000102
Maximum	9.9000002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.1000319 × 10⁸
Q1	2.1237001 × 10⁹
median	3.9049212 × 10⁹
Q3	7.3087501 × 10⁹
95-th percentile	9.2973006 × 10⁹
Maximum	9.9000002 × 10⁹
Range	9.8990001 × 10⁹
Interquartile range (IQR)	5.18505 × 10⁹

Descriptive statistics

Standard deviation	2.8766182 × 10⁹
Coefficient of variation (CV)	0.62796372
Kurtosis	-1.2606031
Mean	4.580867 × 10⁹
Median Absolute Deviation (MAD)	2.4030788 × 10⁹
Skewness	0.24314969
Sum	9.8190883 × 10¹³
Variance	8.2749325 × 10¹⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9900000190	1	< 0.1%
1000102	1	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
Other values (21425)	21425	> 99.9%

Value	Count	Frequency (%)
1000102	1	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%

date
Date

Distinct	372
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	334.9 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

High correlation

Distinct	4000
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	541645.37

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	75000
5-th percentile	213500
Q1	324844
median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7625000
Interquartile range (IQR)	320156

Descriptive statistics

Standard deviation	367322.88
Coefficient of variation (CV)	0.67816121
Kurtosis	34.72392
Mean	541645.37
Median Absolute Deviation (MAD)	150000
Skewness	4.0360699
Sum	1.1610169 × 10¹⁰
Variance	1.349261 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	172	0.8%
350000	167	0.8%
550000	157	0.7%
500000	151	0.7%
425000	149	0.7%
325000	146	0.7%
400000	144	0.7%
375000	137	0.6%
300000	131	0.6%
525000	128	0.6%
Other values (3990)	19953	93.1%

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	1	< 0.1%
89000	1	< 0.1%
89950	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
6885000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4668000	1	< 0.1%
4500000	1	< 0.1%
4489000	1	< 0.1%

bedrooms
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3701889

Minimum	0
Maximum	11
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	11
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.90692006
Coefficient of variation (CV)	0.26910066
Kurtosis	1.8525996
Mean	3.3701889
Median Absolute Deviation (MAD)	1
Skewness	0.51796722
Sum	72240
Variance	0.822504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	9731	45.4%
4	6849	32.0%
2	2736	12.8%
5	1586	7.4%
6	265	1.2%
1	194	0.9%
7	38	0.2%
8	13	0.1%
0	13	0.1%
9	6	< 0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
0	13	0.1%
1	194	0.9%
2	2736	12.8%
3	9731	45.4%
4	6849	32.0%
5	1586	7.4%
6	265	1.2%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	265	1.2%
5	1586	7.4%
4	6849	32.0%
3	9731	45.4%
2	2736	12.8%

bathrooms
Real number (ℝ)

High correlation

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.7517145

Minimum	0
Maximum	8
Zeros	85
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.73485532
Coefficient of variation (CV)	0.41950633
Kurtosis	1.998447
Mean	1.7517145
Median Absolute Deviation (MAD)	1
Skewness	0.90060207
Sum	37548
Variance	0.54001234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	10481	48.9%
1	8253	38.5%
3	2217	10.3%
4	335	1.6%
0	85	0.4%
5	48	0.2%
6	12	0.1%
7	2	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
0	85	0.4%
1	8253	38.5%
2	10481	48.9%
3	2217	10.3%
4	335	1.6%
5	48	0.2%
6	12	0.1%
7	2	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
8	2	< 0.1%
7	2	< 0.1%
6	12	0.1%
5	48	0.2%
4	335	1.6%
3	2217	10.3%
2	10481	48.9%
1	8253	38.5%
0	85	0.4%

sqft_living
Real number (ℝ)

High correlation

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2082.7265

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1430
median	1920
Q3	2550
95-th percentile	3770
Maximum	13540
Range	13250
Interquartile range (IQR)	1120

Descriptive statistics

Standard deviation	919.16248
Coefficient of variation (CV)	0.44132653
Kurtosis	5.2487448
Mean	2082.7265
Median Absolute Deviation (MAD)	550
Skewness	1.4709482
Sum	44643243
Variance	844859.66
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	136	0.6%
1440	133	0.6%
1400	132	0.6%
1800	128	0.6%
1660	128	0.6%
1820	127	0.6%
1560	124	0.6%
1010	124	0.6%
1540	122	0.6%
1720	122	0.6%
Other values (1028)	20159	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

High correlation

Distinct	9782
Distinct (%)	45.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15136.064

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	520
5-th percentile	1800
Q1	5040
median	7614
Q3	10696.5
95-th percentile	43560
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5656.5

Descriptive statistics

Standard deviation	41539.543
Coefficient of variation (CV)	2.7444085
Kurtosis	284.07091
Mean	15136.064
Median Absolute Deviation (MAD)	2616
Skewness	13.043382
Sum	3.2444153 × 10⁸
Variance	1.7255336 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	355	1.7%
6000	285	1.3%
4000	249	1.2%
7200	218	1.0%
4800	118	0.6%
7500	118	0.6%
4500	112	0.5%
8400	109	0.5%
9600	108	0.5%
3600	102	0.5%
Other values (9772)	19661	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	334.9 KiB

1	12446
2	8370
3	619

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21435
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

Most occurring characters

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	12446	58.1%
2	8370	39.0%
3	619	2.9%

waterfront
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	334.9 KiB

0	21272
1	163

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21435
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21272	99.2%
1	163	0.8%

view
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	334.9 KiB

0	19319
2	962
3	507
1	331
4	316

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21435
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19319	90.1%
2	962	4.5%
3	507	2.4%
1	331	1.5%
4	316	1.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	334.9 KiB

3	13911
4	5645
5	1686
2	164
1	29

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21435
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	4
3rd row	3
4th row	4
5th row	3

Common Values

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	13911	64.9%
4	5645	26.3%
5	1686	7.9%
2	164	0.8%
1	29	0.1%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6617681

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1742752
Coefficient of variation (CV)	0.15326426
Kurtosis	1.1901124
Mean	7.6617681
Median Absolute Deviation (MAD)	1
Skewness	0.77028604
Sum	164230
Variance	1.3789222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8895	41.5%
8	6044	28.2%
9	2606	12.2%
6	1995	9.3%
10	1130	5.3%
11	396	1.8%
5	234	1.1%
12	89	0.4%
4	29	0.1%
13	13	0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	234	1.1%
6	1995	9.3%
7	8895	41.5%
8	6044	28.2%
9	2606	12.2%
10	1130	5.3%
11	396	1.8%

Value	Count	Frequency (%)
13	13	0.1%
12	89	0.4%
11	396	1.8%
10	1130	5.3%
9	2606	12.2%
8	6044	28.2%
7	8895	41.5%
6	1995	9.3%
5	234	1.1%
4	29	0.1%

sqft_above
Real number (ℝ)

High correlation

Distinct	946
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1790.9955

Minimum	290
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	290
5-th percentile	850
Q1	1200
median	1560
Q3	2220
95-th percentile	3400
Maximum	9410
Range	9120
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	829.02996
Coefficient of variation (CV)	0.4628878
Kurtosis	3.3949976
Mean	1790.9955
Median Absolute Deviation (MAD)	450
Skewness	1.4441781
Sum	38389988
Variance	687290.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	210	1.0%
1010	204	1.0%
1200	203	0.9%
1220	186	0.9%
1140	183	0.9%
1400	180	0.8%
1180	177	0.8%
1060	177	0.8%
1340	174	0.8%
1250	173	0.8%
Other values (936)	19568	91.3%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Real number (ℝ)

Zeros

Distinct	306
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291.73105

Minimum	0
Maximum	4820
Zeros	13015
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.78793
Coefficient of variation (CV)	1.517795
Kurtosis	2.7121305
Mean	291.73105
Median Absolute Deviation (MAD)	0
Skewness	1.5769613
Sum	6253255
Variance	196061.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13015	60.7%
600	220	1.0%
700	215	1.0%
500	211	1.0%
800	206	1.0%
400	184	0.9%
1000	147	0.7%
900	143	0.7%
300	141	0.7%
200	106	0.5%
Other values (296)	6847	31.9%

Value	Count	Frequency (%)
0	13015	60.7%
10	1	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.0996

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1952
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.385501
Coefficient of variation (CV)	0.014908177
Kurtosis	-0.6542564
Mean	1971.0996
Median Absolute Deviation (MAD)	23
Skewness	-0.4746777
Sum	42250519
Variance	863.50768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	454	2.1%
2005	450	2.1%
2004	429	2.0%
2003	422	2.0%
2007	415	1.9%
1977	415	1.9%
1978	384	1.8%
1968	379	1.8%
2008	367	1.7%
Other values (106)	17161	80.1%

Value	Count	Frequency (%)
1900	86	0.4%
1901	29	0.1%
1902	27	0.1%
1903	45	0.2%
1904	44	0.2%
1905	74	0.3%
1906	91	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	199	0.9%
2012	169	0.8%
2011	130	0.6%
2010	143	0.7%
2009	229	1.1%
2008	367	1.7%
2007	415	1.9%
2006	454	2.1%

yr_renovated
Real number (ℝ)

Zeros

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.733753

Minimum	0
Maximum	2015
Zeros	20525
Zeros (%)	95.8%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	402.43998
Coefficient of variation (CV)	4.7494649
Kurtosis	18.60965
Mean	84.733753
Median Absolute Deviation (MAD)	0
Skewness	4.5394263
Sum	1816268
Variance	161957.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20525	95.8%
2014	91	0.4%
2013	37	0.2%
2003	36	0.2%
2005	35	0.2%
2007	35	0.2%
2000	35	0.2%
2004	26	0.1%
2006	24	0.1%
1990	24	0.1%
Other values (60)	567	2.6%

Value	Count	Frequency (%)
0	20525	95.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	16	0.1%
2014	91	0.4%
2013	37	0.2%
2012	11	0.1%
2011	13	0.1%
2010	18	0.1%
2009	22	0.1%
2008	18	0.1%
2007	35	0.2%
2006	24	0.1%

zipcode
Real number (ℝ)

High correlation

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.861

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98117
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	53.470342
Coefficient of variation (CV)	0.00054518259
Kurtosis	-0.84971172
Mean	98077.861
Median Absolute Deviation (MAD)	42
Skewness	0.40818655
Sum	2.102299 × 10⁹
Variance	2859.0775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	599	2.8%
98038	587	2.7%
98115	576	2.7%
98052	571	2.7%
98117	548	2.6%
98042	547	2.6%
98034	543	2.5%
98118	499	2.3%
98023	492	2.3%
98006	490	2.3%
Other values (60)	15983	74.6%

Value	Count	Frequency (%)
98001	359	1.7%
98002	197	0.9%
98003	276	1.3%
98004	315	1.5%
98005	168	0.8%
98006	490	2.3%
98007	139	0.6%
98008	283	1.3%
98010	99	0.5%
98011	194	0.9%

Value	Count	Frequency (%)
98199	316	1.5%
98198	275	1.3%
98188	135	0.6%
98178	258	1.2%
98177	254	1.2%
98168	264	1.2%
98166	250	1.2%
98155	442	2.1%
98148	56	0.3%
98146	281	1.3%

lat
Real number (ℝ)

Distinct	5034
Distinct (%)	23.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.56015

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.4711
median	47.572
Q3	47.678
95-th percentile	47.74963
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.2069

Descriptive statistics

Standard deviation	0.1386018
Coefficient of variation (CV)	0.0029142423
Kurtosis	-0.67364154
Mean	47.56015
Median Absolute Deviation (MAD)	0.1047
Skewness	-0.48808973
Sum	1019451.8
Variance	0.01921046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5322	17	0.1%
47.6624	17	0.1%
47.6846	17	0.1%
47.5491	17	0.1%
47.6955	16	0.1%
47.6886	16	0.1%
47.6711	16	0.1%
47.686	15	0.1%
47.6647	15	0.1%
47.5402	15	0.1%
Other values (5024)	21274	99.2%

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

High correlation

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.21369

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21435
Negative (%)	100.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.23
Q3	-122.124
95-th percentile	-121.979
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.204

Descriptive statistics

Standard deviation	0.14089699
Coefficient of variation (CV)	-0.001152874
Kurtosis	1.0454454
Mean	-122.21369
Median Absolute Deviation (MAD)	0.101
Skewness	0.88185586
Sum	-2619650.5
Variance	0.019851962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	114	0.5%
-122.3	110	0.5%
-122.362	102	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	98	0.5%
-122.357	95	0.4%
-122.288	95	0.4%
-122.365	94	0.4%
-122.346	93	0.4%
Other values (742)	20435	95.3%

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

High correlation

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1988.3451

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2370
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	880

Descriptive statistics

Standard deviation	685.70034
Coefficient of variation (CV)	0.34485983
Kurtosis	1.5932641
Mean	1988.3451
Median Absolute Deviation (MAD)	410
Skewness	1.1057971
Sum	42620177
Variance	470184.96
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	193	0.9%
1440	190	0.9%
1560	190	0.9%
1500	179	0.8%
1460	168	0.8%
1800	166	0.8%
1580	165	0.8%
1720	165	0.8%
1610	164	0.8%
1760	163	0.8%
Other values (767)	19692	91.9%

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

High correlation

Distinct	8689
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12786.339

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	334.9 KiB

Quantile statistics

Minimum	651
5-th percentile	1989.4
Q1	5100
median	7620
Q3	10087.5
95-th percentile	37197.6
Maximum	871200
Range	870549
Interquartile range (IQR)	4987.5

Descriptive statistics

Standard deviation	27376.05
Coefficient of variation (CV)	2.1410391
Kurtosis	150.31762
Mean	12786.339
Median Absolute Deviation (MAD)	2508
Skewness	9.4951763
Sum	2.7407517 × 10⁸
Variance	7.4944813 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	425	2.0%
4000	355	1.7%
6000	286	1.3%
7200	210	1.0%
4800	144	0.7%
7500	142	0.7%
8400	115	0.5%
4500	110	0.5%
3600	110	0.5%
5100	109	0.5%
Other values (8679)	19429	90.6%

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

Interactions

Correlations

	bathrooms	bedrooms	condition	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated	zipcode
bathrooms	1.000	0.469	0.107	0.390	0.594	0.008	0.013	0.219	0.453	0.627	0.165	0.664	0.496	0.047	0.040	0.108	0.100	0.506	0.052	-0.170
bedrooms	0.469	1.000	0.051	0.195	0.382	0.006	-0.023	0.192	0.345	0.540	0.230	0.648	0.445	0.218	0.202	0.050	0.026	0.179	0.017	-0.168
condition	0.107	0.051	1.000	0.248	0.153	0.030	0.057	0.081	0.023	0.107	0.094	0.060	0.062	0.041	0.014	0.024	0.017	0.249	0.068	0.073
floors	0.390	0.195	0.248	1.000	0.373	0.060	0.180	0.230	0.146	0.429	0.178	0.300	0.294	0.018	0.015	0.021	0.017	0.525	0.024	0.246
grade	0.594	0.382	0.153	0.373	1.000	0.018	0.103	0.221	0.657	0.712	0.092	0.716	0.662	0.153	0.157	0.142	0.118	0.499	0.016	-0.179
id	0.008	0.006	0.030	0.060	0.018	1.000	-0.005	0.006	0.002	0.002	0.001	0.000	-0.001	-0.117	-0.115	0.028	0.006	0.026	-0.018	-0.005
lat	0.013	-0.023	0.057	0.180	0.103	-0.005	1.000	-0.144	0.456	-0.027	0.114	0.029	0.026	-0.121	-0.116	0.068	0.034	-0.126	0.025	0.249
long	0.219	0.192	0.081	0.230	0.221	0.006	-0.144	1.000	0.061	0.385	-0.201	0.284	0.380	0.371	0.373	0.085	0.097	0.411	-0.076	-0.578
price	0.453	0.345	0.023	0.146	0.657	0.002	0.456	0.061	1.000	0.541	0.252	0.644	0.572	0.076	0.064	0.208	0.320	0.098	0.102	-0.006
sqft_above	0.627	0.540	0.107	0.429	0.712	0.002	-0.027	0.385	0.541	1.000	-0.167	0.844	0.697	0.273	0.255	0.089	0.082	0.471	0.030	-0.277
sqft_basement	0.165	0.230	0.094	0.178	0.092	0.001	0.114	-0.201	0.252	-0.167	1.000	0.327	0.129	0.037	0.031	0.159	0.135	-0.179	0.063	0.115
sqft_living	0.664	0.648	0.060	0.300	0.716	0.000	0.029	0.284	0.644	0.844	0.327	1.000	0.747	0.306	0.285	0.148	0.140	0.351	0.052	-0.206
sqft_living15	0.496	0.445	0.062	0.294	0.662	-0.001	0.026	0.380	0.572	0.697	0.129	0.747	1.000	0.361	0.367	0.146	0.089	0.334	-0.006	-0.287
sqft_lot	0.047	0.218	0.041	0.018	0.153	-0.117	-0.121	0.371	0.076	0.273	0.037	0.306	0.361	1.000	0.923	0.040	0.014	-0.039	0.008	-0.320
sqft_lot15	0.040	0.202	0.014	0.015	0.157	-0.115	-0.116	0.373	0.064	0.255	0.031	0.285	0.367	0.923	1.000	0.035	0.000	-0.018	0.009	-0.327
view	0.108	0.050	0.024	0.021	0.142	0.028	0.068	0.085	0.208	0.089	0.159	0.148	0.146	0.040	0.035	1.000	0.595	0.042	0.109	0.075
waterfront	0.100	0.026	0.017	0.017	0.118	0.006	0.034	0.097	0.320	0.082	0.135	0.140	0.089	0.014	0.000	0.595	1.000	0.032	0.092	0.080
yr_built	0.506	0.179	0.249	0.525	0.499	0.026	-0.126	0.411	0.098	0.471	-0.179	0.351	0.334	-0.039	-0.018	0.042	0.032	1.000	-0.215	-0.315
yr_renovated	0.052	0.017	0.068	0.024	0.016	-0.018	0.025	-0.076	0.102	0.030	0.063	0.052	-0.006	0.008	0.009	0.109	0.092	-0.215	1.000	0.062
zipcode	-0.170	-0.168	0.073	0.246	-0.179	-0.005	0.249	-0.578	-0.006	-0.277	0.115	-0.206	-0.287	-0.320	-0.327	0.075	0.080	-0.315	0.062	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
2497	1000102	20150422T000000	300000	6	3	2400	9373	2	3	7	2400	0	1991	0	98002	47.3262	-122.214	2060	7316
6735	1200019	20140508T000000	647500	4	1	2060	26036	1	4	8	1160	900	1947	0	98166	47.4444	-122.351	2590	21891
8411	1200021	20140811T000000	400000	3	1	1460	43000	1	3	7	1460	0	1952	0	98166	47.4434	-122.347	2250	20023
8809	2800031	20150401T000000	235000	3	1	1430	7599	1	4	6	1010	420	1930	0	98168	47.4783	-122.265	1290	10320
3557	3600057	20150319T000000	402500	4	2	1650	3504	1	3	7	760	890	1951	2013	98144	47.5803	-122.294	1480	3504
18521	3600072	20150330T000000	680000	4	2	2220	5310	1	5	7	1170	1050	1951	0	98144	47.5801	-122.294	1540	4200
3200	3800008	20150224T000000	178000	5	1	1990	18200	1	3	7	1990	0	1960	0	98178	47.4938	-122.262	1860	8658
21063	5200087	20140709T000000	487000	4	2	2540	5001	2	3	9	2540	0	2005	0	98108	47.5423	-122.302	2360	6834
4333	6200017	20141112T000000	281000	3	1	1340	21336	1	4	5	1340	0	1945	0	98032	47.4023	-122.273	1340	37703
16715	7200080	20141104T000000	239000	4	2	1980	10585	1	2	6	1980	0	1924	0	98055	47.4836	-122.214	1360	7810

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
1716	9839300875	20140514T000000	800000	3	1	1700	4400	1	4	8	1700	0	1906	98122	47.6120	-122.292	1610	4180
4679	9839301055	20140626T000000	670000	3	1	1490	4400	1	4	7	1490	0	1906	98122	47.6113	-122.292	1560	4400
4821	9839301060	20150406T000000	650500	3	1	1740	4400	1	3	8	1740	0	1903	98122	47.6115	-122.292	1740	4400
13028	9839301165	20141001T000000	998500	2	1	1570	4400	1	4	8	1570	0	1914	98122	47.6112	-122.293	1850	4400
11654	9842300036	20141008T000000	415885	3	1	1310	4163	1	4	7	1310	0	1964	98126	47.5301	-122.381	1120	4166
16737	9842300095	20140725T000000	365000	5	2	1600	4168	1	3	7	1600	0	1927	98126	47.5297	-122.381	1190	4168
3260	9842300485	20150311T000000	380000	2	1	1040	7372	1	5	7	840	200	1939	98126	47.5285	-122.378	1930	5150
7621	9842300540	20140624T000000	339000	3	1	1100	4128	1	4	7	720	380	1942	98126	47.5296	-122.379	1510	4538
20979	9895000040	20140703T000000	399900	2	1	1410	1005	1	3	9	900	510	2011	98027	47.5446	-122.018	1440	1188
15951	9900000190	20141030T000000	268950	3	1	1320	8100	1	3	6	880	440	1943	98166	47.4697	-122.351	1000	8100

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample